Lets you calculate formulas, change the type of references used in formulas, use SmartSum to create instant totals, and paste any of 104 @functions, with or without arguments, into a formula.
Calculates all formulas in the worksheet, or converts the formula you're editing to its value.
Cycles the selected address in a formula through eight combinations of relative or absolute sheet, row, and column. Also changes from an absolute to a relative range name.
Cycles the selected address in a formula through eight combinations of relative or absolute sheet, row, and column. Also changes from an absolute to a relative range name. Available only if you're creating or editing a cell entry.
Automatically sums values above or to the left of the selected cell or range, or throughout a range if cells in the bottom or right column are blank.
Automatically sums values above or to the left of the selected cell or range, or throughout a range if cells in the bottom or or right column are blank. Not available if a drawn object is selected.
Adds the values in a list. @SUM is a statistical @function.
Averages the values in a list. @AVG is a statistical @function.
Lists @functions alphabetically by name, ready for you to paste into a formula.
Lets you insert an @function into a formula without using placeholder arguments.
Lets you insert an @function into a formula without using placeholder arguments. Not available if the console is closed.
Automatically inserts argument placeholders between parentheses when you choose an @function name from this menu.
Automatically inserts argument placeholders between parentheses when you choose an @function name from this menu. Not available if the console is closed.
